# SQL commands to create and populate the MySQL database for
# CNT 4714 - Summer 2012
#
# delete the database if it already exists
drop database if exists mailinglist;

#create a new database named mailinglist
create database mailinglist;

#switch to the new database
use mailinglist;

#create the schemas for the four relations in this database
create table contacts (
    ID integer unsigned zerofill auto_increment not null,
    LastName varchar(30),
    FirstName varchar(30),
    Email varchar(30),
    Phone varchar(14),
    Magazine varchar(60),
    OS varchar(30),
    primary key (ID)
);


